SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
CREATE VIEW dbo.vwlPaquetesDePlaza
AS
SELECT     idPaquete AS ID, Org.CUISE, TipoPaquete, Mnemo
FROM         dbo.tb_PaquetesDePlazas PP
INNER JOIN Tb_Organizaciones Org ON Org.IdOrganizaciones = PP.Organizacion




GO
GRANT SELECT ON  [dbo].[vwlPaquetesDePlaza] TO [CentroDeDesignaciones]
GRANT SELECT ON  [dbo].[vwlPaquetesDePlaza] TO [Direcciones De Nivel]
GRANT SELECT ON  [dbo].[vwlPaquetesDePlaza] TO [PersonalDocente]
GRANT SELECT ON  [dbo].[vwlPaquetesDePlaza] TO [SoloVer]
GO
